<?php
$id	= $row['id'];
	$spcode = $row['spcode'];
	$name = $row['name'];
	$phone = $row['phone'];
	$email = $row['email'];
	$sex = $row['sex'];
	$address = $row['address'];
	$city = $row['city'];
	$serial = $row['serial'];
	$lo = $row['lo'];
	$object = $row['object'];
	$status = $row['status'];
	$state = $row['state'];
	$confirm = $row['confirm'];
	$process = $row['process'];
	$receiver = $row['receiver'];
	$carer = $row['carer'];
	$start_time = (date("d-m-Y H:i:s",$row['start_time']));
	$QueryDay = (date("d",$row['start_time']));
	$QueryCurrentDay = date("d");
	$QueryCurrentMonth = (date("m",$row['start_time']));
	$QueryMonth = date("m");
	$QueryCurrentYear = (date("Y",$row['start_time']));
	$QueryYear = date("Y");
		$i++;
		echo '<tr>
							<td style="border-bottom:1px solid #666666;"><a href="view_care_report.php?do=view&id='.$id.'">'.$i.'</a></td>
							<td style="border-bottom:1px solid #666666;">'.$name.' ['.$phone.']</td>
							<td style="border-bottom:1px solid #666666;"><a href="view_care_report.php?do=view&id='.$id.'">'.nl2br($confirm).'</a></td>
							<td style="border-bottom:1px solid #666666;">'.$start_time.'</td>';
							echo '
								<td style="border-bottom:1px solid #666666;">'.$carer.'</td>
								<td style="border-bottom:1px solid #666666;" class="'.$state.'">'.$state.' (<a href="")>'.$receiver.'</a>)</td>
							</tr>';						

?>